data = xlsread('fin_data.xlsx','sheet1','C4:NF328');
col_1 = data(2:end,4);
col_2 = data(2:end,11);
col_3 = data(2:end,8);
col = [col_1,col_2,col_3];
[m,n] = size(col);

for i = 1:283
    if col(i,n) > 5
        col([i],:) = [];
    end
end

col_A = col;
[row,col] = size(col_A);
for i = 1:row
    col_A(i,n+1) = 0;

    col_A(i,n+1) = col_A(i,n+1) + col_A(i,1)*0.3 + col_A(i,2)*0.7;
end

% xlswrite('1.xlsx',col);
